﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using Anglo.Models;


namespace Anglo.DB
{
    public class AngloDBStatic: AngloDB, IDisposable
    {
        public AngloDBStatic(string connectionString) 
        {
        }

        public void Dispose()
        {
        }

        public override JobDetails GetJob(int jobID)
        {
            JobDetails result = new JobDetails()
            {
                Discipline = "CAD Draughting",
                Industry = "Oil & Gas",
                JobDescription = @"Offshore Methods Draughter required to report to the Drawing Office Principal. The successful candidate will create engineering animations; create 3D models for ROV simulator and other third party applications, manage and organise the animations library.
Assist in all Drawing Office activities regarding the specific activity and operations requirements for ongoing Projects, administration, general and related engineering requirements along with project related Drawing Office administration.
Ensure the maintenance of CAD System Quality Standards is acceptable to Client and industry and review same on regular basis to ensure realisation of such quality is always achieved. Arrange and maintain in-house training and development of CAD personnel in respect of the latest developments and releases of software used in the group.
Provide the linkage between CAD area and IT Department in respect of CAD software and hardware issues. Ensure the maintenance of all CAD Library files with relevant and updated standards, specifications, equipment, listings, etc. Ensure all project activities comply with the relevant Acts, legal demands and ethical standards related to CAD systems and software. Be familiar with Subsea EPC contractors procedures, policy and objectives.
Ensure that all work is carried out in conformance with the corporate policies, procedures and relevant legislation. Work in a sensible and safe manner at all times and comply with the requirements of office safety procedures. Report and safety concerns or hazardous situations to immediate supervisor. Minimum HNC/HND in Civil / Structural Engineering or equivalent. Detailed knowledge of CAD Systems and their applications, with particular emphasis on AutoCAD & SOLIDWORKS. A reasonable knowledge of offshore working desirable. To apply please email me on sophie.sauze@anglo.com.",
                JobFullTitle = "CAD Administrator, Aberdeen",
                JobID = 12060,
                JobReference = "6662/112",
                JobTitle = "CAD Administrator",
                JobType = "Permanent",
                Location = "Grampian",
                Pay = "£ Neg",
                Region = "Scotland"
            };
            return result;
        }


        public override List<JobHierarchy> GetJobsByIndustry(int id)
        {
            return new List<JobHierarchy>()
            {
                new JobHierarchy()
                {
                     JobID = 1060,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£ Neg",
                     IndustryHeader = true,
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1061,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£80,000"
                },
                new JobHierarchy()
                {
                     JobID = 1062,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Graduate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£ Neg",
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1063,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Principal/Associate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£45,000"
                }
            };
        }

        public override Industry GetIndustryByID(int id)
        {
            return new Industry()
            {
                Description = "Architect jobs, Architectural Assistants jobs, CAD technician jobs, Landscape design jobs, Interior design jobs, Urban design jobs.",
                ShortDescription = "Architecture Job Vacancies - Architectural Jobs.",
                Title = "Architecture Jobs",
                IndustryID = id
            };
        }

        public override List<JobHierarchy> GetJobsByDiscipline(int id)
        {
            return new List<JobHierarchy>()
            {
                new JobHierarchy()
                {
                     JobID = 1060,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£ Neg",
                     IndustryHeader = true,
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1061,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£80,000"
                },
                new JobHierarchy()
                {
                     JobID = 1062,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Graduate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£ Neg",
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1063,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Principal/Associate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£45,000"
                }
            };
        }

        public override Discipline GetDisciplineByID(int id)
        {
            return new Discipline()
            {
                Description = "Administration Jobs",
                DisciplineID = id,
                ShortDescription = "",
                Title = "Administration Jobs"
            };
        }

        public override List<JobHierarchy> GetJobsByLocation(int id)
        {
            return new List<JobHierarchy>()
            {
                new JobHierarchy()
                {
                     JobID = 1060,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£ Neg",
                     IndustryHeader = true,
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1061,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£80,000"
                },
                new JobHierarchy()
                {
                     JobID = 1062,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Graduate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£ Neg",
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1063,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Principal/Associate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£45,000"
                }
            };
        }

        public override Location GetLocationByID(int id)
        {
            return new Location()
            {
                Description = "South America",
                LocationID = id,
                ShortDescription = "",
                Title = "South America"
            };
        }

        public override List<JobHierarchy> GetJobsByParams(SearchParameters search)
        {
            return new List<JobHierarchy>()
            {
                new JobHierarchy()
                {
                     JobID = 1060,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£ Neg",
                     IndustryHeader = true,
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1061,
                     Discipline = "Architects",
                     Industry = "Architecture Jobs",
                     JobTitle = "Senior-Level-Architect",
                     Location = "Eastern Europe",
                     Pay = "£80,000"
                },
                new JobHierarchy()
                {
                     JobID = 1062,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Graduate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£ Neg",
                     DisciplineHeader = true
                },
                new JobHierarchy()
                {
                     JobID = 1063,
                     Discipline = "Landscape",
                     Industry = "Architecture Jobs",
                     JobTitle = "Principal/Associate-Landscape-Architect",
                     Location = "Lothian",
                     Pay = "£45,000"
                }
            };
        }

    }
}
